Tally Request XML formats, Tally Integration with any platform

Tally Request XMLs

Tally Integration, Tally ERP 9 Integration with Node.JS

Tally ERP Data Accessing via Node.js

Getting Tally ERP data using Server side javascript (node.js)

1. Create a NodeJS, express application
2. Install necessary plugins such as cors,xml,body-parser and request.

Server.js

var express = require('express');
var router = express.Router();
var bodyParser = require('body-parser');
var cors = require('cors');
var request = require('request');
require('body-parser-xml')(bodyParser);
var xml = require('xml');
var async = require('async');
/*Tally xml query*/
var xmlstring = '<ENVELOPE>
<HEADER>
<TALLYREQUEST>Export DATA</TALLYREQUEST>
</HEADER>
<BODY>
<EXPORTDATA>
<REQUESTDESC>
<REPORTNAME>LIST of Companies</REPORTNAME>
<STATICVARIABLES>
<SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
</STATICVARIABLES>
</REQUESTDESC>
</EXPORTDATA> </BODY>
</ENVELOPE>';
let app = express();
app.use(bodyParser.json());
/* use CORS to avoid net::ERR_CONNECTION_RESET */
app.use(cors);
app.post("/",(req,res) =>{ /*
Dynamic Tally xml Query parameter
const dbrequest = req.body.datarequest;
const params = req.body.params;
*/
var options = {
uri: 'http://localhost:9000',

method: 'POST',

headers: { 'Content-Type': 'text/xml;
charset:UTF-8',
'Content-Length': Buffer.byteLength(xmlstring)},
body: req.body.xmlstr
};
var result="";
async.parallel([
function(callback) {
/* tally data fetch from local tally server*/
var url = "http://localhost:9000";
request(options, function(err, response, body) {
// JSON body
if(err) { console.log(err);
callback(true);
return;
}

result = body;
callback(false, body);
});

}

],function(err, results) {
if(err) { console.log(err);
res.send(500,"Server Error");
return;
}
res.send("result--->"+result);
}
);
}

app.listen(4000,'localhost');

TallyPrime List of Companies XML Request

TallyPrime XML Request for List of Companies

<ENVELOPE>
<HEADER>
<VERSION>1</VERSION>
<TALLYREQUEST>Export</TALLYREQUEST>
<TYPE>Data</TYPE>
<ID>List of Companies</ID>
</HEADER>
<BODY>
<DESC>
<TDL>
<TDLMESSAGE>
<REPORT NAME="List of Companies" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
<FORMS>List of Companies</FORMS>
</REPORT>
<FORM NAME="List of Companies" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
<TOPPARTS>List of Companies</TOPPARTS>
<XMLTAG>"List of Companies"</XMLTAG>
</FORM>
<PART NAME="List of Companies" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
<TOPLINES>List of Companies</TOPLINES>
<REPEAT>List of Companies : Collection of Companies</REPEAT>
<SCROLLED>Vertical</SCROLLED>
</PART>
<LINE NAME="List of Companies" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
<LEFTFIELDS>Name</LEFTFIELDS>
</LINE>
<FIELD NAME="Name" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
<SET>$Name</SET>
<XMLTAG>"NAME"</XMLTAG>
</FIELD>
<COLLECTION NAME="Collection of Companies" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
<TYPE>Company</TYPE>
<FETCH>NAME</FETCH>
</COLLECTION>
</TDLMESSAGE>
</TDL>
</DESC>
</BODY>
</ENVELOPE>

Party wise Sales in xml format

How to export All Party wise Sales data from tally using XML request

Request for XML Format Party Sales for Integration from Tally.

<ENVELOPE>
<HEADER>
<TALLYREQUEST>Export Data</TALLYREQUEST>
</HEADER>

<BODY>
<EXPORTDATA>
<REQUESTDESC>
         <REPORTNAME>Group Summary</REPORTNAME>
  <STATICVARIABLES>

   <SVCURRENTCOMPANY>company</SVCURRENTCOMPANY>
   <SVEXPORTFORMAT>$$SysName:html</SVEXPORTFORMAT>
   <SVFROMDATE TYPE="Date">#fromdate</SVFROMDATE>
                        <SVTODATE TYPE="Date">#todate</SVTODATE>
                        <DSPShowNett>No</DSPShowNett>


                           <GroupName>22003 SUNDRY DEBTORS</GroupName>
                          <DSPShowTrans>Yes</DSPShowTrans>
                          <IFLTPrompt>Voucher</IFLTPrompt>
                          <IFLTMethod>Invoice</IFLTMethod>
                          <IFLTAttr>Yes</IFLTAttr>

                </STATICVARIABLES>

</REQUESTDESC>

</EXPORTDATA>
</BODY>
</ENVELOPE>

How to filter tally xml response based on voucher number?

Tally Request XML for Exporting Voucher filter by specific voucher number

Tally Integration with Third Party Application using PHP,ASP.NET, VB.Net,JSP
<ENVELOPE>
<HEADER>
<VERSION>1</VERSION>
<TALLYREQUEST>Export</TALLYREQUEST>
<TYPE>Collection</TYPE>
<ID>List of All Sales Vouchers</ID>
</HEADER>
<BODY>
<DESC>

<STATICVARIABLES>
<SVCURRENTCOMPANY>#company</SVCURRENTCOMPANY>
<SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
<SVFROMDATE TYPE="Date">#fromdate</SVFROMDATE>
<SVTODATE TYPE="Date">#todate</SVTODATE>

</STATICVARIABLES>

<TDL>
<TDLMESSAGE>

<COLLECTION NAME="List of All Sales Vouchers" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
<TYPE>Voucher</TYPE>

<FETCH>ADDRESS.LIST,BASICBUYERADDRESS.LIST,DATE,
CLASSNAME,PARTYNAME,PERSISTEDVIEW,
BASICDUEDATEOFPYMT,LEDGERENTRIES.LIST</FETCH>

<FILTERS>TYPOFSALES</FILTERS>

</COLLECTION>

<SYSTEM TYPE="Formulae" NAME="TYPOFSALES">
$VOUCHERTYPENAME equal to "#TALLYVOUCHERTYPE" AND $VOUCHERNUMBER equal to "#TALLYVCHNO"
</SYSTEM>

</TDLMESSAGE>
</TDL>
</DESC>
</BODY>
</ENVELOPE>

Tally data to Power BI

TallyPrime Integration with Power BI

Tally Reports available in Power BI

Tally ERP / Tally Prime we can integrate with Microsoft Power BI is posible with 100%, we can get Power 2 Reports using Tally BI + Microsoft Power BI

Is it possible to connect Tally and Microsoft Power BI?

Step 6 : Enter your any one of the web report URL in URL Parts (as per step 1)

Step 7 : Select HTTP Request Header Parameters as Content-Type and enter "Text/Json" as a data and click "OK" button

Step 8 : do Power BI Kitchen work for the result
Changing the data types, creating Measure using DAX, creating new columns in power bi etc.,